﻿CREATE TABLE [dbo].[ServiceInstance] (
    [ServiceInstanceID]           UNIQUEIDENTIFIER NOT NULL,
    [NeedsUpgrade]                BIT              NULL,
    [NeedsUpgradeIncludeChildren] BIT              NULL,
    [ServerID]                    UNIQUEIDENTIFIER NULL,
    [ServiceID]                   UNIQUEIDENTIFIER NULL,
    [Status]                      VARCHAR (200)    NULL,
    [TypeName]                    VARCHAR (200)    NULL,
    CONSTRAINT [PK_ServiceInstance] PRIMARY KEY CLUSTERED ([ServiceInstanceID] ASC),
    CONSTRAINT [FK_ServiceInstance_Server] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);

